d9a123fc2df999e2c3741e731e5118224b871e41,src/main/java/applets/etsmtl/ca/news/db/NouvellesDAO.java,NouvellesDAO,find,#String#,17

Before Change


    public Nouvelle find(String id) {
        try {
                ResultSet result = this.connection
                                .createStatement(
                                        ResultSet.TYPE_SCROLL_INSENSITIVE,
                                        ResultSet.CONCUR_READ_ONLY
                                        ).executeQuery(
                                            "SELECT * FROM nouvelles WHERE id = '" +id+"'"
                                        );
                if(result.first()) {
                        return getDataFromResult(result);
                }

After Change


public class NouvellesDAO extends DAO<Nouvelle> {

    @Override
    public Nouvelle find(String id) {
        try {
            String findById = "SELECT * FROM nouvelles WHERE id = ?";
            PreparedStatement st = this.connection.prepareStatement(findById,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            st.setString(1, id);
            ResultSet result = st.executeQuery();
            if(result.first()) {
                Nouvelle nouvelle = getDataFromResult(result);
                result.close();
                st.close();
                return nouvelle;
            }